package com.saas.sql;

public class DeleBuy
{
  public static final String tf_f_SEL_SPEC_SALE = "select info.title,date_format(info.pub_date,'%Y-%m-%d') pub_date,orde.stock_id,info.cust_id,cust.cust_name from tf_f_infolist_del info ,tf_f_customer cust ,tf_f_stockorder orde where info.cust_id = cust.CUST_ID and info.info_id=orde.STOCK_ID";
  public static final String tf_f_SEL_BUY_DEL = "select info.title,date_format(info.pub_date,'%Y-%m-%d') pub_date,orde.stock_id, info.cust_id,cust.cust_name from tf_f_infolist_del info ,tf_f_customer cust,tf_f_stockorder orde where info.cust_id = cust.CUST_ID and info.info_id=orde.STOCK_ID and info.pub_date > STR_TO_DATE(:V_START_DATE,'%Y-%m-%d') and info.pub_date < STR_TO_DATE(:V_END_DATE,'%Y-%m-%d')";
  public static final String tf_f_DELE_CALLBACK = "insert into tf_f_infolist select * from tf_f_infolist_del where info_id=:V_INFO_ID limit 0,1";
  public static final String tf_f_DELE = "delete from tf_f_infolist_del where info_id=:V_INFO_ID";
}

